package com.example.mini_notepad.db;

import android.provider.BaseColumns;

public abstract class NoteContracts {
	
	private NoteContracts(){}
	
	public static final String DATABASE_NAME = "notesdb";
	public static final int DATABASE_VERSION = 1;
	
	public static final String CREATE_TABLE_NOTE = 
			"create table " + Note.TABLE_NAME 
			+ "(" + Note._ID +" integer primary key autoincrement, "
			+ Note.COLUMN_NAME_TITLE + " varchar(50) not null, "
			+ Note.COLUMN_NAME_CONTENT + " text not null, "
			+ Note.COLUMN_NAME_NOTE_TYPE + " integer not null, "
			+ Note.COLUMN_NAME_CREATE_TIME + " text not null, "
			+ Note.COLUMN_NAME_NOTIFY_TIME + " text not null," 
			+ Note.COLUMN_NAME_DURATION + " integer not null);";
	
//	public static final String CREATE_TABLE_RECORD_NOTE = 
//			"create table " + RecordNote.TABLE_NAME 
//			+ "(" + RecordNote._ID +" integer primary key autoincrement, "
//			+ RecordNote.COLUMN_NAME_TITLE + " varchar(50) not null, "
//			+ RecordNote.COLUMN_NAME_FILE_PATH + " text not null, "
//			+ RecordNote.COLUMN_NAME_CREATE_TIME + " timestamp not null, "
//			+ RecordNote.COLUMN_NAME_NOTIFY_TIME + " timestamp not null);";
	
	public static final String DROP_TABLE_NOTE = 
			"drop table if exists " + Note.TABLE_NAME + ";";
	
//	public static final String DROP_TABLE_RECORD_NOTE =
//			"drop table if exists " + RecordNote.TABLE_NAME + ";";
	
	public static abstract class Note implements BaseColumns{
		public static final String TABLE_NAME = "note";
		// table columns
		public static final String COLUMN_NAME_TITLE = "title";
		public static final String COLUMN_NAME_CONTENT= "content";
		public static final String COLUMN_NAME_NOTE_TYPE = "type";
		public static final String COLUMN_NAME_CREATE_TIME = "create_time";
		public static final String COLUMN_NAME_NOTIFY_TIME = "notify_time";
		public static final String COLUMN_NAME_DURATION = "duration";
	}
	
//	public static abstract class RecordNote implements BaseColumns{
//		public static final String TABLE_NAME = "record_note";
//		// table columns
//		public static final String COLUMN_NAME_TITLE = "title";
//		public static final String COLUMN_NAME_FILE_PATH= "file_path";
//		public static final String COLUMN_NAME_CREATE_TIME = "create_time";
//		public static final String COLUMN_NAME_NOTIFY_TIME = "notify_time";
//	}
//	
	

}
